<template>
    <div class="app-container">
      <el-row :gutter="10" class="mb5">
        <el-col :span="1.5">
          <el-button
            plain
            icon="el-icon-plus"
            size="mini"
            @click="handleAdd"
            v-hasPermi="['system:conn:add']"
          >新增</el-button>
        </el-col>
        <el-col :span="1.5">
          <el-button
            plain
            icon="el-icon-edit"
            size="mini"
            :disabled="single"
            @click="handleUpdate"
            v-hasPermi="['system:conn:edit']"
          >修改</el-button>
        </el-col>
        <el-col :span="1.5">
          <el-button
            plain
            icon="el-icon-delete"
            size="mini"
            :disabled="multiple"
            @click="handleDelete"
            v-hasPermi="['system:conn:remove']"
          >删除</el-button>
        </el-col>
        <el-col :span="1.5">
        </el-col>
        <el-form :model="queryParams" ref="queryForm" :inline="true" v-show="showSearch" label-width="68px" class="el-form-search">
            <el-form-item label="连接名称" prop="connName" class="el-form-search-item">
                              <el-input
                                      v-model="queryParams.connName"
                                      placeholder="请输入连接名称"
                                      clearable
                                      size="mini"
                                      @keyup.enter.native="handleQuery"
                              />
                          </el-form-item>  
            <el-form-item class="el-form-search-item">
                  <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button>
                  <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button>
              </el-form-item>
          </el-form>
      </el-row>
  
      <el-table :height="tableHeight" v-loading="loading" :data="connList" @selection-change="handleSelectionChange">
        <el-table-column type="selection" width="55" align="center" />
        <el-table-column label="编号" align="center" prop="id" width="50" />
        <el-table-column label="名称" align="center" prop="connName"  width="100"  />
        <el-table-column label="url" align="center" prop="connUrl"  />
        <el-table-column label="用户" align="center" prop="dbUser" width="50" />

        <el-table-column label="操作" align="center" class-name="small-padding fixed-width" width="150">
          <template slot-scope="scope">
            <el-button
              size="mini"
              type="text"
              icon="el-icon-edit"
              @click="handleUpdate(scope.row)"
              v-hasPermi="['system:conn:edit']"
            >修改</el-button>
            <el-button
              size="mini"
              type="text"
              icon="el-icon-delete"
              @click="handleDelete(scope.row)"
              v-hasPermi="['system:conn:remove']"
            >删除</el-button>
          </template>
        </el-table-column>
      </el-table>
  
      <pagination
        v-show="total>0"
        :total="total"
        :page.sync="queryParams.pageNum"
        :limit.sync="queryParams.pageSize"
        @pagination="getList"
      />
  
      <!-- 添加或修改数据库连接对话框
      jdbc:mysql://localhost:3306/finmis1??useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
    -->
      <el-dialog :title="title" :visible.sync="open" width="800px" append-to-body :close-on-click-modal="false" v-dialogDrag>
        <el-form ref="form" :model="form" :rules="rules" label-width="120px">
          <el-form-item label="连接的url" prop="connUrl">
            <el-input v-model="form.connUrl" placeholder="请输入连接的url" />
          </el-form-item>
          <el-form-item label="数据库用户" prop="dbUser">
            <el-input v-model="form.dbUser" placeholder="请输入数据库用户" />
          </el-form-item>
          <el-form-item label="数据库密码" prop="dbPass">
            <el-input v-model="form.dbPass" placeholder="请输入数据库密码" />
          </el-form-item>
          <el-form-item label="连接名称" prop="connName">
            <el-input :disabled="title=='修改数据库连接'" v-model="form.connName" placeholder="请输入连接名称" />
          </el-form-item>
        </el-form>
        <div slot="footer" class="dialog-footer">
            <el-button type="success" @click="testConn" :loading="testConnLoading">测试连接</el-button>
          <el-button type="primary" @click="submitForm">确 定</el-button>
          <el-button @click="cancel">取 消</el-button>
        </div>
      </el-dialog>
    </div>
  </template>
  
  <script>
  import { listConn, getConn, delConn, addConn, updateConn ,testConn} from "@/api/db/conn";
  
  export default {
    name: "Conn",
    data() {
      return {
        // 表格高度
        tableHeight: document.documentElement.clientHeight - 180,
        // 遮罩层
        loading: true,
        // 选中数组
        ids: [],
        // 非单个禁用
        single: true,
        // 非多个禁用
        multiple: true,
        // 显示搜索条件
        showSearch: true,
        // 总条数
        total: 0,
        // 数据库连接表格数据
        connList: [],
        // 弹出层标题
        title: "",
        // 是否显示弹出层
        open: false,
        // 查询参数
        queryParams: {
          pageNum: 1,
          pageSize: 20,
          orderByColumn: "id",
          isAsc: "desc",
          connName: null,
        },
        // 表单参数
        form: {},
        // 表单校验
        rules: {
        },

        testConnLoading: false,

      };
    },
    created() {
      this.getList();
    },
    methods: {

        testConn(){

          this.testConnLoading=true;

             //测试数据库连接   
           testConn (this.form).then(response => {
            this.testConnLoading=false;
            this.$modal.msgSuccess("连接成功"); 
           }).catch(error => {
              this.testConnLoading=false;
           });
        },

      /** 查询数据库连接列表 */
      getList() {
        this.loading = true;
        listConn(this.queryParams).then(response => {
          this.connList = response.rows;
          this.total = response.total;
          this.loading = false;
        });
      },
      // 取消按钮
      cancel() {
        this.open = false;
        this.reset();
      },
      // 表单重置
      reset() {
        this.form = {
          connName: null,
          connUrl: null,
          dbPass: null,
          dbUser: null,
          id: null
        };
        this.resetForm("form");
      },
      /** 搜索按钮操作 */
      handleQuery() {
        this.queryParams.pageNum = 1;
        this.getList();
      },
      /** 重置按钮操作 */
      resetQuery() {
        this.resetForm("queryForm");
        this.handleQuery();
      },
      // 多选框选中数据
      handleSelectionChange(selection) {
        this.ids = selection.map(item => item.id)
        this.single = selection.length!==1
        this.multiple = !selection.length
      },
      /** 新增按钮操作 */
      handleAdd() {
        this.reset();
        this.open = true;
        this.title = "添加数据库连接";
      },
      /** 修改按钮操作 */
      handleUpdate(row) {
        this.reset();
        const id = row.id || this.ids
        getConn(id).then(response => {
          this.form = response.data;
          this.open = true;
          this.title = "修改数据库连接";
        });
      },
      /** 提交按钮 */
      submitForm() {
        this.$refs["form"].validate(valid => {
          if (valid) {
            if (this.form.id != null) {
              updateConn(this.form).then(response => {
                this.$modal.msgSuccess("修改成功");
                this.open = false;
                this.getList();
              });
            } else {
              addConn(this.form).then(response => {
                this.$modal.msgSuccess("新增成功");
                this.open = false;
                this.getList();
              });
            }
          }
        });
      },
      /** 删除按钮操作 */
      handleDelete(row) {
        const ids = row.id || this.ids;
        this.$modal.confirm('是否确认删除记录？').then(function() {
          return delConn(ids);
        }).then(() => {
          this.getList();
          this.$modal.msgSuccess("删除成功");
        }).catch(() => {});
      },
      /** 导出按钮操作 */
      handleExport() {
        this.download('db/conn/export', {
          ...this.queryParams
        }, `conn_${new Date().getTime()}.xlsx`)
      }
    }
  };
  </script>
  